create external table jms_dm.dm_send_no_arrival_detail_dt
(
date_time date COMMENT 'date_time' ,
id string COMMENT '问题件表id' ,
waybill_no string COMMENT '问题件表运单号' ,
create_time timestamp COMMENT '问题件登记时间' ,
registration_network_name   string COMMENT '登记网点' ,
registration_network_code string COMMENT '登记网点code' ,
is_error  bigint COMMENT '是否异常，1是，0否' ,
is_error_type string COMMENT '异常，判断类型'
 )
comment '有发未到问题件'
PARTITIONED BY ( dt string COMMENT '时间分区')
stored as parquet
LOCATION '/dw/hive/jms_dm.db/external/dm_send_no_arrival_detail_dt'
TBLPROPERTIES (     'discover.partitions' = 'false',  'parquet.column.index.access' = 'true');
